CREATE VIEW [dbo].[vCsRegistration] AS SELECT
    Order_Meet.MEETING AS EventCode,
    Order_Meet.REGISTRANT_CLASS AS RegistrantClass,
    Orders.BALANCE AS Balance,
    Orders.BT_ID AS BillToId,
    Orders.CO_MEMBER_TYPE AS CompanyMemberType,
    Orders.COMPANY AS Company,
    Orders.COMPANY_SORT AS CompanySort,
    Orders.FULL_NAME AS FullName,
    Orders.LAST_FIRST AS LastFirst,
    Orders.LINE_TAXABLE AS LineTaxable,
    Orders.LINE_TOTAL AS LineTotal,
    Orders.MEMBER_TYPE AS MemberType,
    Orders.ORDER_DATE AS OrderDate,
    Orders.ORDER_NUMBER AS OrderNumber,
    Orders.ORDER_TYPE_CODE AS OrderTypeCode,
    Orders.ST_ID AS ShipToId,
    Orders.STATUS AS Status,
    Orders.TOTAL_CHARGES AS TotalCharges,
    Orders.TOTAL_PAYMENTS AS TotalPayments
FROM Order_Meet
    INNER JOIN Orders
        ON Order_Meet.ORDER_NUMBER = Orders.ORDER_NUMBER
WHERE Orders.ORDER_TYPE_CODE = 'MEETING'

GO